Microsoft Azure Synapse Analytics data types
The following table shows the Microsoft Azure Synapse Analytics data warehouse data types that are supported when using Qlik Compose and the default mapping from Qlik Compose data types.
For information on how to view the data type that is mapped from the source, see the section for the source database you are using.
| Qlik Compose data types | Microsoft Azure Synapse Analytics data types |
|---|---|
|
BIGINT |
BIGINT |
|
DECIMAL |
DECIMAL (p,s) |
|
INTEGER |
INTEGER |
|
DATE |
DATE |
|
DATETIME |
DATETIME2 (s) |
|
TIME |
TIME |
|
GUID |
VARCHAR (38) |
| BIGINTAUTOINC | BIGINT |
|
BYTE |
VARBINARY (Length) |
| VARCHAR (Length) | VARCHAR (Length) |
| NVARCHAR (Length) | NVARCHAR (Length) |